
<!DOCTYPE html>
<!--

    Copyright (c) 2017, 2019 Oracle and/or its affiliates. All rights reserved.

    This program and the accompanying materials are made available under the
    terms of the Eclipse Public License v. 2.0, which is available at
    http://www.eclipse.org/legal/epl-2.0.

    This Source Code may also be made available under the following Secondary
    Licenses when the conditions for such availability set forth in the
    Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
    version 2 with the GNU Classpath Exception, which is available at
    https://www.gnu.org/software/classpath/license.html.

    SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0

-->
<!-- Portions Copyright [2019] [Payara Foundation and/or its affiliates] -->
<html lang="en">
  <head>
    <meta charset="utf-8"/>
    <title>stop-database</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="css/style.css" rel="stylesheet">
    <script src="https://use.fontawesome.com/96c4d89611.js"></script>
  </head>
  <body>
<table id="doc-title" cellspacing="0" cellpadding="0">
  <tr>
  <td align="left" valign="top">
  <b>stop-database</b><br />
  </td>
  </tr>
</table>
<hr />

<table width="90%" id="top-nav" cellspacing="0" cellpadding="0">
	<colgroup>
		<col width="12%"/>
		<col width="12%"/>
		<col width="*"/>
	</colgroup>
	<tr>
		<td align="left">
		<a href="stop-cluster.html">
			<span class="vector-font"><i class="fa fa-arrow-circle-left" aria-hidden="true"></i></span>
			<span style="position:relative;top:-2px;">Previous</span>
		</a>
		</td>

		<td align="left">
		<a href="stop-domain.html">
			<span class=" vector-font"><i class="fa fa-arrow-circle-right vector-font" aria-hidden="true"></i></span>
			<span style="position:relative;top:-2px;">Next</span>
		</a>
		</td>

		<td align="right">
		<a href="toc.html">
			<span class=" vector-font"><i class="fa fa-list vector-font" aria-hidden="true"></i></span>
			<span style="position:relative;top:-2px;">Contents</span>
		</a>
		</td>
	</tr>
</table>


<div id="preamble">
<div class="sectionbody">
<div class="paragraph">
<p><a id="stop-database-1"></a><a id="GSRFM00239"></a><a id="stop-database"></a></p>
</div>
</div>
</div>
<div class="sect1">
<h2 id="_stop_database">stop-database</h2>
<div class="sectionbody">
<div class="paragraph">
<p>stops the Java DB</p>
</div>
<div id="sthref2158" class="paragraph">
<p>Synopsis</p>
</div>
<div class="listingblock">
<div class="content">
<pre class="prettyprint highlight"><code class="language-oac_no_warn" data-lang="oac_no_warn">asadmin [asadmin-options] stop-database [--help]
[--dbuser db-user]
[--dbhost host] [--dbport port-no]</code></pre>
</div>
</div>
<div id="sthref2159" class="paragraph">
<p>Description</p>
</div>
<div class="paragraph">
<p>The <code>stop-database</code> subcommand stops a process of the Java DB server.
Java DB server is available for use with \{product---name} and is based
upon Apache Derby. The database is typically started with the
<a href="start-database.html#start-database-1"><code>start-database</code>(1)</a>
subcommand. A single host can have multiple database server processes
running on different ports. The <code>stop-database</code> subcommand stops the
database server process for the specified port only.</p>
</div>
<div class="paragraph">
<p>This subcommand is supported in local mode only.</p>
</div>
<div id="sthref2160" class="paragraph">
<p>Options</p>
</div>
<div class="dlist">
<dl>
<dt class="hdlist1">asadmin-options</dt>
<dd>
<p>Options for the <code>asadmin</code> utility. For information about these
options, see the <a href="asadmin.html#asadmin-1m"><code>asadmin</code>(1M)</a> help page.</p>
</dd>
<dt class="hdlist1"><code>--help</code></dt>
<dt class="hdlist1"><code>-?</code></dt>
<dd>
<p>Displays the help text for the subcommand.</p>
</dd>
<dt class="hdlist1"><code>--dbuser</code></dt>
<dd>
<p>The user name of the Java DB user that is to stop the server process.
This option is required only when Java DB user authentication is
enabled.<br>
If this option is omitted, no user is specified. By default, Java DB
user authentication is disabled, so no user or password is required.</p>
</dd>
<dt class="hdlist1"><code>--dbhost</code></dt>
<dd>
<p>The host name or IP address of the Java DB server process. The default
is the IP address 0.0.0.0, which denotes all network interfaces on the
host where you run the <code>stop-database</code> subcommand.</p>
</dd>
<dt class="hdlist1"><code>--dbport</code></dt>
<dd>
<p>The port number where the Java DB server listens for client
connections. The default is 1527.</p>
</dd>
</dl>
</div>
<div id="sthref2161" class="paragraph">
<p>Examples</p>
</div>
<div class="paragraph">
<p><a id="GSRFM765"></a><a id="sthref2162"></a></p>
</div>
<div class="paragraph">
<p>Example 1   Stopping Java DB</p>
</div>
<div class="paragraph">
<p>This example stops Java DB on host host1 and port 5001.</p>
</div>
<div class="listingblock">
<div class="content">
<pre class="prettyprint highlight"><code class="language-oac_no_warn" data-lang="oac_no_warn">asadmin&gt; stop-database --dbhost host1 --dbport 5001
Connection obtained for host: host1, port number 5001.
Shutdown successful.
Command stop-database executed successfully.</code></pre>
</div>
</div>
<div id="sthref2163" class="paragraph">
<p>Exit Status</p>
</div>
<div class="paragraph">
<p>The exit status applies to errors in executing the <code>asadmin</code> utility.
For information on database errors, see the <code>derby.log</code> file. This file
is located in the directory you specify by using the <code>--dbhome</code> option
when you run the <code>start-database</code> subcommand. If you did not specify
<code>--dbhome</code>, the value of <code>DERBY_INSTALL</code> defaults to
as-install`/javadb`.</p>
</div>
<div class="dlist">
<dl>
<dt class="hdlist1">0</dt>
<dd>
<p>command executed successfully</p>
</dd>
<dt class="hdlist1">1</dt>
<dd>
<p>error in executing the command</p>
</dd>
</dl>
</div>
<div id="sthref2164" class="paragraph">
<p>See Also</p>
</div>
<div class="paragraph">
<p><a href="asadmin.html#asadmin-1m"><code>asadmin</code>(1M)</a></p>
</div>
<div class="paragraph">
<p><a href="start-database.html#start-database-1"><code>start-database</code>(1)</a></p>
</div>
</div>
</div>

<hr />

<table width="90%" id="bottom-nav" cellspacing="0" cellpadding="0">
	<colgroup>
		<col width="12%"/>
		<col width="12%"/>
		<col width="*"/>
	</colgroup>
	<tr>		
		<td align="left">
		<a href="stop-cluster.html">
			<span class=" vector-font"><i class="fa fa-arrow-circle-left" aria-hidden="true"></i></span>
			<span style="position:relative;top:-2px;">Previous</span>
		</a>
		</td>

		<td align="left">
		<a href="stop-domain.html">
			<span class="vector-font"><i class="fa fa-arrow-circle-right vector-font" aria-hidden="true"></i></span>
			<span style="position:relative;top:-2px;">Next</span>
		</a>
		</td>

		<td align="right">
		<a href="toc.html">
			<span class="vector-font"><i class="fa fa-list vector-font" aria-hidden="true"></i></span>
			<span style="position:relative;top:-2px;">Contents</span>
		</a>
		</td>
	</tr>
</table>

<span id="copyright">
        <img src="/resource/reference/img/eclipse_foundation_logo_tiny.png" height="20px" alt="Eclipse Foundation Logo" align="top"/>&nbsp;            
        <span >Copyright&nbsp;&copy;&nbsp;2019,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span>
</span>

</body>
</html>
